Senior BI Developer

Company Description

Chromalloy has expanded from a gas turbine parts repair business into an OEM supplier of production parts and advanced repairs and services for gas turbines used in aviation and power applications. Chromalloy serves the airline, military, marine and energy segments with a broad range of services at locations around the globe.

Chromalloy is a subsidiary of Sequa Corporation. Sequa Corporation is a diversified industrial company with operations in the aerospace, metal coatings and automotive industries. Sequa is a Carlyle Group company. For additional information, visit .

Job Description

• Develop and improve solutions spanning data processing activities from the staging to star schemas and reporting view’s / tables and finally into SSAS.
• Create and Modify SSIS packages. Create an design and implementation checks in SSIS packages
• Create data load mappings, import/export methods, Incremental /Full load data from Source systems to various targets.
• Power BI development and administration.
• Building Analysis Services reporting models.
• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Excellent in analytical thinking for translating data into informative visuals and reports.
• Able to implement row level security on data and understand application security layer models in Power BI.
• Proficient in making DAX queries in Power BI desktop.
• Expertise in using advance level calculations on the data set.
• Responsible for design methodology and project documentation.
• Develop tabular and multidimensional models that are compatible with warehouse standards.
• Adept in developing, publishing and scheduling Power BI reports as per the business requirements.
• Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.

Qualifications

• 5+ years of experience as a BI Developer.
• 5+ years of experience with data preparation, data gateway, and data warehousing projects.
• Experience in ETL (Extract, Transform, Load) using Microsoft Integration Services / SSIS
• Background in data warehouse design (e.g. dimensional modeling) and data mining
• Working knowledge and experiences in SSIS, SSRS, SSAS and SQL Server development tools.
• Working knowledge and experiences in data design / dimensional data modeling.
• Advanced experience in writing DAX queries in Power BI Desktop and creating informative dashboards.
• Ability to work independently with little or no supervision.
• Ability to multi-task and manage competing priorities in a dynamic work environment.
• Possess proficient analytical, problem solving and decision-making skills.
• Strong interpersonal skills including teamwork, facilitation, communication, and the ability to influence.

Additional Information

The Business Analyst will be a key role to understand what a business does, what a business target is, and how those goals are accomplished. This role includes understanding business and technical terms, then liaising both functions to support decision making in the short term and long term. The candidate will participate in a range of analytical and data analysis activities which will enhance the department's understanding of financial and operational results, leading to increased efficiencies, lower operational expense levels, and revenue opportunities.