Analytics and Power BI Developer

General Dynamics - Sterling Heights, MI

Full-time - Mid Level

Sterling Heights, MI

10,001+ employees

Transportation Equipment Manufacturing

About the position

As an Analytics and Power BI Engineer, you will be part of a dynamic Operational Excellence team which drives measurable improvements throughout the Engineering organization. The primary responsibility for this role is to understand customer needs, determine appropriate data requirements, find, evaluate, prioritize and implement solutions that provide measurable data driven improvements. The Engineer will be expected to use tools including but not limited to databases, various analytics tools, Excel, and Power BI at a minimum. In this role, you will create and test data models that ensure data accuracy in dashboard reporting, providing organizational insights and process trends. You will leverage and utilize the internal business systems and associated data to support business needs, while maintaining the current suite of Engineering dashboards. You will also be responsible for investigating and resolving data delivery issues for Power BI dashboards, including data source issues, Power BI data refresh issues, and server and report refresh issues as required. Additionally, you will support and understand data security and data governance policies, lead and facilitate cross-functional teams to coordinate the implementation of comprehensive automation and improvement initiatives, and interface with IT/Security to identify, understand, and resolve technical challenges. Conducting requirements analysis with report consumers and stakeholders on dashboard visualizations will be essential, as well as determining data needs and cleaning and filtering data for various analysis requests.

Responsibilities

• Create and test data models that ensure data accuracy in dashboard reporting, providing organizational insights and process trends.
• Leverage and utilize the internal business systems and associated data to support business needs.
• Maintain the current suite of Engineering dashboards.
• Investigate and resolve data delivery issues for Power BI dashboards, including data source issues, Power BI data refresh issues, and server and report refresh issues.
• Support and understand data security and data governance policies (CUI).
• Lead and facilitate cross-functional teams to coordinate the implementation of comprehensive automation/improvement initiatives.
• Interface with IT/Security to identify, understand, and resolve planned and unplanned technical challenges.
• Determine data needs, clean and filter data for various analysis requests.
• Conduct requirements analysis with report consumers/stakeholders on dashboard visualizations and determine data sources to architect the data model that provides the required business need.

Requirements

• Bachelor's degree in data Analytics or other Engineering degree supplemented with appropriate experience.
• A minimum of 7 years of experience.
• Proficiency in business intelligence analytics: development and tools for data analytics, Power BI, data modeling, DAX Query, and data cleaning.
• Must be willing to work in an office, lab, prototype, and test site environments.
• Be a self-starter and work in a fast-paced environment.
• Strong written and oral communication skills.
• Able to work overtime when required.
• This position requires eligibility to obtain a US security clearance.

Benefits

• Healthcare including medical, dental, vision, HSA and Flex Spending
• Competitive base pay and incentive pay that rewards individual and team performance, and comprehensive benefits.
• 401k Match (6%)
• Educational Assistance
• 9-80 Work Schedule (This position's standard work schedule is a 9/80. The 9/80 schedule allows employees who work a nine-hour day Monday through Thursday to take every other Friday off)
• On-going learning opportunities within a diverse, inclusive and rewarding work environment
• Onsite cafeteria, fitness center, and outdoor fitness track