Lead Developer, Power Platforms
American Bureau of Shipping (ABS)

Job Info

---

The Data Warehouse Developer participates in the design and development, and management of the Data Warehouse, including ETLs, data modeling, cube design, performance tuning, and deployment and management of cubes. Participate in new and ongoing project work.

What You Will Do:

• Identify and participate in process improvement initiatives that improve the internal customer experience, enhance workflows, and/or improve the work environment.
• Use best practices for Azure Data Warehouse design and development.
• Develop scripts, perform database support activities, and conduct performance tuning and database design, dimensional analysis, and modeling.
• Support the maintenance of an extensive set of Azure Data Factories for Extract, Transform, and Load (ETL) data manipulation.
• Support, with guidance, the areas of Data Governance, Master Data Management, Analytics, Data Warehousing, Scorecards, Dashboards, Business Performance Monitoring, and Data Mining.
• Provide functional assistance in various data management, warehousing, business intelligence, and Big Data solutions.
• Standardize cross-departmental data definitions, KPIs, and calculations.
• Maintain, enhance, and create enterprise and application-level reports using SQL Server Report Service (SSRS) and other Business Intelligence (BI) tools.
• Provide input to status reports for senior management.
• Create custom SQL to query complex data models most effectively for the database and the application servers.
• Participate as a team member with business stakeholders, developers, infrastructure teams, and project management groups.
• Assist in monitoring system performance, reliability, availability, recoverability, and cost of the Azure DW environment.
• Support other special projects and duties, as assigned.

What You Will Need:

Education and Experience

• Bachelor's degree in a related IT field required and equivalent related work experience
• Typically requires a minimum of 3 years of previous work-related experience

Knowledge, Skills, and Abilities

• Experience using Microsoft Azure Synapse Workspace, Data Factory, Azure Analysis Server, PowerBI, and Visual Basic required with the development of database/data warehouse/data mart solutions.
• Solid understanding of the software development process, including requirement gathering, analysis/design, development tools/technologies, release/version control, and contemporary testing methodologies.
• Good working knowledge of MDX and SQL queries performance tuning.
• Good working knowledge in Data Mapping, Data Modeling, Data Mining, and Data Warehousing/Mart.
• Basic understanding of Microsoft BI Stack, including Power Apps, Power Query, Power Pivot, and Power View.
• Basic understanding of DevOps.
• Ability to develop a working knowledge of ABS Rules, Guides, statutory regulations, and related instructions, as well as the ABS Employee Safety Policy.

Reporting Relationships:

Reports directly to a manager level position or above.

ABOUT US

We set out more than 160 years ago to promote the security of life and property at sea and preserve the natural environment. Today, we remain true to our mission and continue to support organizations facing a rapidly evolving seascape of challenging regulations and new technologies. Through it all, we are anchored by a vision and mission that help our clients find clarity in uncertain times.

ABS is a global leader in marine and offshore classification and other innovative safety, quality, and environmental services. We're at the forefront of supporting the global energy transition at sea, the application of remote and autonomous marine systems, cutting-edge technical solutions, and many more exciting advancements. Our commitment to safety, reliability, and efficiency is ever-present, guiding our clients to safer and more efficient operations.

About Our Benefits

ABS Bureau proudly offers a variety of industry-leading benefits designed to enhance the life and well-being of our employees and their families. These benefits include, but are not limited to, medical insurance (PPO and HD), dental and vision insurance, Health Savings Account (HSA), Flexible Savings Account (FSA), life insurance, accidental death and dismemberment insurance, disability leave programs, parental leave program, paid holidays, and paid vacation time. The Company provides an Employee Assistance Plan (EAP) that offers support in personal wellness, including work-life services. ABS Bureau also offers a 401K plan with a generous company match, subject to plan requirements.

Equal Opportunity

ABS Bureau is committed to the equal employment opportunity of its employees and prohibits discrimination against any employee or qualified applicant based on race, color, creed, religion, national origin, sex, gender identity, age, disability, marital status, sexual orientation, citizenship status or veteran status, or other non-work-related characteristics that may be protected under the law of the Federal Government or specific state employment laws.

Notice

ABS and Affiliated Companies (ABS) will not pay a fee to any third-party agency without a valid ABS Master Service Agreement (MSA) authorized and signed by Human Resources. Any resume, CV, application, or other forms of candidate submission provided to any employee of ABS without a valid MSA on file will be considered property of ABS, and no fee will be paid.

Other

This job description is not intended, and should not be construed, to be an all-inclusive list of responsibilities, skills, efforts or working conditions associated with the job of the incumbent. It is intended to be an accurate reflection of the principal job elements essential for making a fair decision regarding the pay structure of the job. #ogjs

---