Power BI Developer / Administrator

ABOUT THE COMPANY

AMETEK, Inc. is a leading global manufacturer of electronic instruments and electromechanical devices with annual sales of approximately $5 billion.

AMETEK has 18,000 colleagues at more than 150 operating locations, and a global network of sales, service and support locations in 30 countries around the world.

The AMETEK Growth Model combines its four growth strategies of Operational Excellence, Strategic Acquisitions, Global & Market Expansion, and New Product Development, with a disciplined focus on cash generation and capital deployment. By executing the AMETEK Growth Model, the company seeks to generate shareholder value by doubling earnings per share over the course of each business cycle.

AMETEK consists of two operating groups, both with highly-differentiated technology and leading positions in niche markets:

Electronic Instruments - a worldwide leader in the design and manufacture of advanced analytical, test and measurement instrumentation for the energy, aerospace, power, research, medical and industrial markets.
Electromechanical - a differentiated supplier of automation and precision motion control solutions, and highly engineered electrical interconnects, specialty metals and thermal management systems.

Key Responsibilities will be:

• Power BI development and administration of model changes
• 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 from various database - Oracle, SQL, etc for Business Intelligence.
• Implementing row level security and application security layer models in Power BI.
• Proficient in making Data Analytics Expressions (DAX) queries in Power BI desktop.
• Responsible for design methodology and project documentation.
• Developing tabular and multidimensional models that are compatible with warehouse standards.
• Developing, publishing and scheduling Power BI reports as per the business requirements.
• Integrating Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation. Developing custom visuals for Power BI.
• Evaluating and drawing conclusions from data related to customer behavior
• Partnering with applications managers to ensure each project meets a specific need and resolves successfully
• Reference: ad4oFiSAo9f_Qtbwb4xuFacX80hly60gGGZgnvSZ5DI.

Qualifications and Skills:

• BS in Computer Science or Information System or similar IT degree
• Minimum 5 years of IT professional experience in analytics, building dashboard using Power BI
• Experience of 5+ years in data preparation, data source integration and databases
• Experience of 5+ years and familiarity with Microsoft Business Intelligence Stack having Power BI, SSAS, SSRS, SSIS, ODBC queries against Oracle, SQL and other databases
• 3 to 4 years of experience working in connecting Power BI to data in star schema design.
• Full understanding of the processes of data quality, data cleansing, and data transformation
• Experience with SQL scripting and other SQL application utilities
• Should have knowledge and skills for secondary tools such as Microsoft Azure, SQL data warehouse, Visual Studio, etc.
• Comfortable in manipulating, integrating, analyzing complex, high-volume, high-dimensionality data from varying, variety of sources
• Ability to effectively communicate with business management to analyze requirements, translate to technical specifications, prototype design and deploy analytical BI solutions
• Demonstrate analytical thinking skills for translating business data into informative visuals and reports.
• Expertise in using advance level calculations on the data set.
• Ability to effectively interact with, present information to, and respond to questions from all levels of the organization users