Business Data Analyst

Denver,ColoradoData Analysis / Data Engineering / BIRemote Work Option : YesJob ID : Employment Type : PermanentPay Rate : Base Salary : $0.00 / hr

Xentity is supporting amazing impactful solutions in the Geospatial, Open Data, Big Data, and IoT world. We like to be on the wave of innovative data initiatives, programs, and solutions for our clients. We hope you are too.

Our employees truly know that they are making small differences that result in positive change in the world with new data flows, scripts, products, and delivery platforms in earth agencies and companies.

You’ll be supporting clients as they move their legacy manual data flows into data-driven automated workflows to support challenges not limited to : , Forest Management, Wildland Fire, Parks, Intelligent Transportation Systems, and Geospatial / Open Data Platforms.

We are looking for someone who thrives in change, growth, and impact.

This role is a traditional business analyst performing and delivering user stories decomposition, evaluating research requirements;

process reengineering; modeling workflows, developing business models. Business analysts will do workflow, requirements, and high-level architecture.

Through process-driven, customer-centric, performance-led analysis, and repeatable systematic procedures, can uncover and present opportunities, findings, and potential alternatives for improvement, savings, efficiencies, effectiveness, trends, and further studies in appropriate analysis.

Business analysis may include operation quality analysis, business case financial modeling, user experience, statistics-based, domain or general corporate policy analysis, requirements analysis, governance analysis, business process analysis, program assessment, industry and market analysis, data lifecycle management, business service portfolio and stakeholder input analysis.

Data involved may be Geospatial, Open Data, Big Data, and IoT data.

Responsibilities :

• Coordinate and facilitate meetings to collect business requirements for both alphanumeric and spatial data needs;
• Research and understand the business data requirements and potential users of assigned data standards development projects;
• Document the business data requirements for each potential user of the data;
• Broad understanding and ability to evaluate and pilot new technology
• Analyze the business data process, procedures, and desired outputs to identify problems and determine optimal solutions;
• Use process modeling techniques to facilitate understanding of business processes and the development of data business rules;
• Develop as-is and to-be process models, use case models, activity diagrams, data models and entity relationship models;
• Use process / workflow software (e.g. Visio. Lucid Charts, ER / Studio Business Architect) to create process models for review by business subject matter experts (SMEs);
• Capture business rules for integration in activity diagrams and data model documentation;
• Develop business requirement documents and create functional specifications for alphanumeric and geospatial data systems;
• Use standard templates to develop written technical documentation (such as user requirements, data standard reports, data standard implementation plans, data quality plans, and metadata);
• Develop and document data quality plans for each appropriate section of developed data standards
• Develop and document appropriate metadata records for the contents of developed data standards.

Required Technical Experience :

• Experience mapping and tracing data from system to system in order to solve a given business or data problem;
• Experience in concepts, practices, and procedures within a natural resource or land management organization;
• Experience working with data stewards, data modelers, business analysts, data administrators, and project managers to interpret and translate business needs into applications and derive alphanumeric and geospatial data requirements including data models, schemas, and domains;
• Experience in identifying and documenting reference data sources, integration processes, and domain values;
• Knowledge of business analysis, modeling, and wire framing software tools such as Microsoft Visio and Balsamiq Mockups;
• General knowledge of high level (conceptual), logical, and physical data models;
• Working knowledge of data modeling software (e.g. Idera ER / Studio Data Architect, Sparx Systems Enterprise Architect or CA ERwin).
• Experience business analysis in ESRI stack and basic GIS, Geospatial awareness
• Preference will be given to candidates that demonstrate knowledge of land resource management concepts and practices

Minimum requirements :

Bachelor's Degree min educ and minimum 8 yrs experience

Previous experience supporting Natural Resources and / or Land Management or similar mission.

Must be able to pass basic NACI, background, drug and reference checks.

Remote Position, with opportunities to be on-site in Denver, CO

Benefits :

• We emphasize a balance of work and life and target 40-50 hour weeks with ample time to refresh with great paid-time off.
• Salary & Bonus Programs - Competitive Salary. Multiple Recognition and Rewards Bonus Programs (Performance Bonus plan reviewed twice annually - total ranging from 2-5% of salary and Business Development Bonus Plan, Employee Referral Bonus Plan, and Company Profit Sharing Plan).
• Paid Time off - Paid Holidays, Personal Time Off, and Sick Leave
• Medical Insurance - Coverage for Major Medical and Surgical, Medical Health Care, Dependents’ Health Care with % of employee or 80% employee and 50% family.

Options to enroll in Dental Insurance, Vision Discount Program, Prescription Discount Program, Group Term Life Insurance, Accidental Death & Dismemberment Insurance, and Professional insurance advisors to guide employees through these benefits as needed.

Solid, managed retirement savings plan including - Multiple (k) funds with traditional and Roth options, Company paid fees, Company Match, Third-party Trust Management with personalized retirement portfolio web analysis tools.

About Xentity

We are a fast-growing data consulting and support services firm - focused on large data programs in data types such as geospatial, open, big, and IoT data.

We have high profile clients and projects that our staff really deliver for, as well enjoy knowing they make a large difference.

Xentity is an EEOC (Equal Employment Opportunity Commission) company and SBA certified small disadvantaged business

Position Titlte : Senior Finance Data Analyst

Location : Denver CO WHQ

Req ID : R23 1549

Posted On : Posted 12 Days Ago Posted 12 Days Ago Posted 4 Days Ago

Time Type : Full time Full time Full time

Description : Who We Are

Who We Are

Johns Manville is a leading manufacturer and marketer of premium-quality insulation and commercial roofing, along with glass fibers and nonwovens for commercial, industrial and residential applications.

Our products are used in a wide variety of industries including building products, aerospace, automotive and transportation, filtration, commercial interiors, waterproofing and wind energy.

A proud member of the Berkshire Hathaway family of companies, we serve customers in more than 80 countries around the globe.

We are committed to delivering positive and powerful experiences, because we are successful only when our employees and customers thrive.

We are passionate, we care about people, we perform at a superior level, and we protect others and our environments.

Pay Range

$91,700.00-$126,100.00 Annual

This is the base salary pay range that an applicant can expect to make upon hire. Pay within this range will vary based upon relevant experience, skills, and education among other factors.

In addition, this position is eligible for an incentive bonus.

Johns Manville, a Berkshire Hathaway Company, is a leader in the manufacturing of premium-quality insulation, commercial roofing and fibers and nonwovens for commercial, industrial and residential applications.

We are looking for an experienced Sr. Financial Data Analyst to join our team to continue in providing data driven insights that transform our business.

The Sr. Finance Data Analyst will be responsible for automating the finance analysis and reporting processes and creating data visualizations and dashboards.

The role will support all phases of finance data related projects, including defining data requirements, data design, data mapping and transformation, and data validation and control.

This includes mining data from primary and secondary sources (mainly SAP FI / CO), defining, supporting and enhancing data sources used for analytics and reorganizing data in a format for ease of consumption.

This role is part of our Finance organization and will partner closely with business unit finance teams in addition to the IT organization.

This position is based out of Denver, CO but we do have a flexible work arrangement which, by way of example, an employee's work week may include both some days at the employee's assigned company work location and some workdays performed remotely from the employee's home.

The schedule of remote work will be based on business and work needs as determined by management. Currently, this position requires work at the JM World Headquarters in Denver, CO and is not fully remote.

Your Day-to-Day :

• Identify opportunities for improvement and translate them into projects.
• Secure buy in from business and corporate stakeholders to ensure project success.
• Lead corporate and business unit finance teams to implement new data modelling, analytics, and presentation technology.
• Initiate and manage new projects and build cross functional teams with corporate business finance, IT, and subject matter experts.
• Employ effective data visualization techniques to tell the business story.
• Develop sustainable, fully automated dashboards to help management quickly assess financial health of the business and identify drivers of performance.
• Reconcile financial information from dashboards to the data source ERP and implement controls to ensure continued accuracy.
• Define requirements for development and maintenance of finance data sets.
• Coordinate with IT team to ensure optimal financial planning system performance.
• Implement process and database changes.

What You Bring to the Team :

• Bachelor's Degree in Business, Finance / Accounting or Information Technology
• Minimum of 7 years of strong IT and / or financial analysis experience
• Ability to develop repeatable, clearly understandable, and comprehensive data visualizations that lead to data driven business decisions
• Demonstrated passion to bridge financial expertise with the latest technology with a goal of delivering business value
• Proven organization and project management skills that demonstrate the ability deliver assignments in a systematic and timely basis
• Proven ability to work with and blend large volumes of data
• Written / verbal communication skills allowing for clear and concise expression of ideas to influence decision making throughout all levels of the organization
• Knowledge of data structures, development, data models and techniques for data mining
• Expert in Microsoft Excel
• Experience with Microsoft Power BI
• Experience with Structured Query Language (SQL)
• Experience in statistical analysis
• Experience with building predictive models
• Experience with Tableau preferred
• Thorough knowledge and prior experience with SAP preferred
• Minimal travel required 0 to 10 days per year
• Work environment is typical of an office setting

Please Keep in Mind

If you do not meet 100% of these requirements, we at JM want to hear from you. So, if you are interested in the role, we encourage you to apply so we can learn how your skills and talents can contribute to our team.

Benefits

Johns Manville (JM) offers a wide range of benefits to employees. Some are subsidized by the company and others are fully employee-paid.

Health benefits include a choice of comprehensive medical plans, a dental plan, vision plan, wellness program and critical illness insurance.

JM sponsors a 401(k) plan which includes a sizeable company match. JM offers paid vacation and also provides paid sick and parental leave for eligible employees.

Additionally, Johns Manville provides basic life Insurance, short-term and long-term disability coverage, an employee assistance program, and business travel accident coverage.

Supplemental life insurance and accidental death and dismemberment insurance are available as well. The company also offers a variety of tax saving accounts;

health spending account, traditional flexible spending account, and a dependent care spending account. JM also offers a tuition reimbursement program for undergraduate and certain graduate programs.

Diversity & Inclusion

Johns Manville believes diversity and inclusion in our workplace is critical for the long-term success of our company. We are committed to retaining, developing and attracting a diverse workforce that fosters an inclusive work environment in which all employees are treated with dignity and respect.

This is the right thing to do for our employees, our company and our communities. Our D&I council is composed of employees from locations across North American & Europe who meet regularly and work to promote and foster an environment of inclusion.

Born from our D&I council is our network of employee resource groups (ERGs) that are focused on supporting diverse communities in the workplace.

Review more about our diversity & inclusion initiatives on JM’s Career page.

Incumbent must be physically able to perform essential job functions. Reasonable accommodations may be made to enable individuals with disabilities to perform essential job functions.

We are proud to be an Equal Opportunity / Affirmative Action employer. We maintain a drug-free workplace and perform pre-employment substance abuse testing.

About Us : Johns Manville is a proud member of the Berkshire Hathaway family of companies, serving customers in more than 80 countries, supplying innovative products to the construction, aerospace, automotive, filtration and energy industries.

With a more than 160-year legacy, we understand that our story continues to grow only with the right people saying, thinking and doing the right things.

Make your story our story. Johns Manville believes diversity and inclusion in our workplace is critical for the long-term success of our company.

We are committed to retaining, developing and attracting a diverse workforce that fosters an inclusive work environment in which all employees are treated with dignity and respect.

This is the right thing to do for our employees, our company and our communities. Read More

PI223385249

Top Skills

• Experience handling large datasets
• In-depth / expert skills with SQL and database query tools
• In-depth ability to analyze, interpret, and present data
• Tableau (other BI tools ok, but not the preference)
• Requirements definition and refinement
• Experience producing insights on poorly defined topics
• Comfortable balancing independent ownership and working with support teams

Nice to have

• AWS experience (S3 / EMR / Lambda)
• Hive / Hadoop or experience working with big data platforms
• Spark
• Data Science
• Python or Bash scripting
• Linux
• Project Management
• Manage priorities and delivery across many workstreams
• Bachelor's degree+ in Computer Science, Computer Information Systems, Engineering, Mathematics or related field

Required Skills : Strong SQL (Joins with 3-4 tables, Windowing, Groupby etc.) Need to be able to do ETL with TSQL, not ETL tools.

Visualization tools - Tableau (ideal) anythign is fine though Data Analysis skills; ability to gather requirements from the business.

Title : Data Analyst

Location : Onsite (Englewood, CO)

Duration : 12+ months contract

NOTE : Open for C2C.

Open for C2C.

Only USC, GC, GC-EAD.

TOP SKILLS :

• SQL Intermediate
• Tableau or other BI Application (Looker, PowerBI)
• Microsoft Office suite (Excel, PowerPoint)
• Alteryx experience (optional / desired)

Summary :

• This individual is charged with creating and delivering actionable insights that influence business decisions in the areas of strategy business planning competition KPI development and new / existing initiatives for analysis and operational optimization.
• In addition to the data and analysis collected and presented to the supported business the expectation is for this individual to use statistical analyses to identify drivers and create strategic recommendations presenting these two key partners.
• This position requires an individual who can integrate knowledge of business and functional priorities to act as a key contributor in a complex and crucial environment.

Responsibilities :

Conduct advanced analysis based on provided requirements utilizing extremely large datasets and complex business requirements that typically involves multiple analytical techniques to drive meaningful change on KPIs and objectives established by the stakeholder.

Assist to shape and providing additional value.

Assist management in shaping methodology and baselining showing independence for projects that are a refresh or similar in scope to past team projects.

Know what technical tool to use to help lead the discussion.

• Incorporate standard best practices for industry measurement and KPIs gauging statistical significance.
• Gather data through advanced SQL while querying across multiple platforms and demonstrating an understanding what is necessary for scripts to return relevant data while maintaining performance tuning and best practices
• Demonstrate ownership in data gathering source choices and methodology as the SME for common SOT sources
• Execute validation checks including data element inconsistencies working with leadership to design and implement solutions also checking against standard business trends to identify outlier
• Partner with DQ / architecture shaping requirements and communicating needs to ensure ingests / automations are structured in a way to meet the business goal.

Demonstrate the ability to provide basic direction when quality issues or adjustments arise.

Produces an often-complex collection of reports graphs summaries and presentations that convey analytic results in an easy to understand and storied manner and align with business needs.

Maintain a focus on flow and context ensuring analysis provides insights that tie to visuals and speaks to drivers and business strategy shifts where appropriate.

• Demonstrate the ability to clearly identify key points and callout deeper insights or tie to other visuals and how it relates to business performance through written communication within analysis
• Develop appropriate visuals to ensure the story is conveyed with the ability to add in multi-dimensional views beyond standard and recommending product output and design best suited to meet business and stakeholder needs
• Review and polish analysis through iterative development focusing on word choice grammar and brand standards as well as seeking out and participating in peer reviews
• Understands meeting etiquette following guidance on when to make comments or ask questions with stakeholders
• Confidently and respectfully responds to leader and / or stakeholder feedback in presentation
• Creates presentation messaging appropriate for the specific audience
• Translates methodology and technical elements clearly and concisely
• Displays business acumen by leveraging recent or expected business performance when generating requirements
• Understands and can speak to annual KPI trends including dependent KPIs. Demonstrates knowledge by identifying a shift from baseline performance and impact on business within analyses
• Shows expertise by confidently identifying and speaking to data resources and KPIs components within analysis
• Can tie related KPI performance within analysis and identify co-dependent KPIs. Demonstrated by anticipating potential follow-up questions
• Understands the importance and basic elements of project planning and can create plan independently
• Follows project plan and communicates progress / roadblocks proactively understands level of details required in communication respects project timeline and maintains clear / concise documentation on requirements project goals methodology and output
• Initiates relevant SME and POC reviews with leader to ensure buy-in and alignment
• Daily utilization of JIRA for tracking all tasks and projects.
• Supports all department objectives and participate in work streams processes training etc. as appropriate.
• bull Regular consistent and punctual attendance. Must be able to work nights and weekends variable schedules as necessary.

Education and Experience Requirements :

• Education Level : Bachelor's Degree or Equivalent MBA preferred.
• Field of Study : Business Intelligence Information Systems Information Sciences Economics Engineering Finance Mathematics Statistics

Years' Experience :

Generally, requires 3-4 years related experience.

Technical Requirements :

• Advanced SQL / Teradata
• Tableau
• Advanced PowerPoint / Think-Cell
• Advanced Excel
• Python / R / Data Modeling optional but preferred

Skill Requirements :

• Promote a culture of excellence meaningful data and reporting data driven discussions actionable insights knowledge sharing and teamwork while maintaining an environment that is professionally aggressive.
• Ensures all projects and data developed is value adding and provides actionable insights.
• Ensure appropriate level of statistical significance in insights help educate and hold stakeholders and team accountable in their design and interpretation of analyses.
• Be a hands-on analytical business partner who enjoys rolling up their sleeves to solve complex business questions through data.
• Formulates and tests hypotheses weighs alternatives and determines appropriate recommendations for actionable insights.
• Demonstrate a commitment to the quality of data sets and reporting created by the team ensuring they are repeatable and sustainable.
• Possesses a balance of general business knowledge ability to work with multi-million record relational databases analytical acumen and presentation skills
• bull Performs in depth research on root cause of data anomalies that are uncovered through normal course

Company Overview ClearChoice was founded in 2005 to bring an innovative and patient-focused approach to solve gaps within the dental industry.

We’ve experienced strong growth and today, we’re the leader in dental implant treatments. Driven by a collective desire to improve the lives of our prospective patients, we help them reclaim their health and confidence.

Beyond restoring teeth, this is about getting their lives back. This mission-focused work has enabled us to achieve four straight years of double-digit company growth, yet we’ve only reached 1% of the population that needs our services.

We are searching for individuals who can help us continue pursuing our goal of reaching prospective patients and transforming their lives.

When you join ClearChoice, you are joining a team of individuals with passion, conviction, and integrity whose mission is to be the platform of hope for our patients.

Come help us write the next chapter of our story! Position Summary In this role, you’ll apply your expertise in quantitative analysis, data wrangling, presentation of data, and a commercially-driven mindset to help leadership and stakeholders see beyond the numbers.

You’ll be a key contributor in the analysis and synthesis of our business drivers to help optimize operational efficiency and effectiveness and fuel company growth.

In this fast-paced role, you will have the opportunity to make a significant impact on customer engagement planning and strategy to drive key business outcomes.

Duties / Responsibilities Utilize creative problem-solving and data analysis throughout all facets of our organization while working on and engaging with a team that is core to developing data-driven solutions.

Collaborate with business partners, documenting their requirements for new Data and Analytics structures that support their workflow and decision-making processes.

Lead analytics projects through the development process, collaborating with a team of data experts, ETL developers, visualization designers and Data Scientists to assure the delivery of a high-quality product.

Be accountable for your analysis generating recommended actions and for those recommendations to make a substantive impact on the business.

Collaborate with the data science team on the design of data models that will satisfy business needs, drive innovation, and conform to existing design principles.

Assuring quality by continuously testing your data products while being developed and after they are deployed in production.

Required Experience and Skills Experience establishing ongoing, effective two-way communication within the team and with business stakeholders to ensure customer satisfaction and product delivery success.

Strong experience in documenting the data requirements, data strategy, data rules then applying them (standardization, cleanse, and validation).

Proficient in scientific research applications, hypothesize and develop analytical approaches for identifying, analyzing, and interpreting trends or patterns in complex data sets 2+ years of hands-on work experience with SQL.

Proficient in one or more languages for applied to statistics, data analysis, and machine learning e.g. Python, R. Familiarity with cloud platforms such as AWS, GCP, Azure to use / deploy analytics solutions.

2+ years of applied analytics in sales, finance, marketing, product, engineering; track record of success. BA or BS in a quantitative field (Business, Math / Statistics, Economics, CS, Engineering, or similar).

Masters in quantitative field desired. Desired Experience 2-4 years of hands-on work experience with SQL. 3+ years of applied analytics in sales, finance, marketing, product, engineering;

track record of success. Systematic application of scientific method of problem solving & application of statistical analytic methods.

e.g. hypothesis testing, regression, classification etc.). 2+ years of data management and consulting experience. Salary Range : 70,000 - 85,000 Powered by JazzHR