Data Architect

Primary Duties

• Perform development activities of the Enterprise Data Warehouse (EDW), optimizing data processes for efficient data flow between source and target systems.
• Architect scalable data solutions to support data integration from various sources and ensure consistent, high-quality data for business reporting.
• Design complex, enterprise-wide data models that align with critical business processes, enabling advanced reporting and analytics.
• Create and maintain SSIS packages and processes to support data migration and integration, ensuring data consistency and accuracy.
• Build and optimize models for large datasets, improving query performance and supporting detailed reporting.
• Design interactive dashboards and visualizations tools, based on business requirements, to facilitate smarter data-driven decision-making.
• Implement dynamic data transformations and calculations, enabling advanced analytics and customized business insights.
• Ensure data quality through data cleansing, transformation, conversion, and aggregation techniques, resolving inconsistencies and improving data reliability.
• Manage stored procedures to streamline data retrieval and reuse.
• Enforce data security to restrict access based on organizational roles.

100% telecommuting is permitted from home office per company policy to support New Era offices or clients located throughout the United States.

Requirements

Education: Bachelor's degree (or foreign educational equivalent) in Computer Science, Data Science or a closely related technical field plus at least 3 years of post-degree, progressive experience in each of the below items; OR, alternatively,

A Master's degree (or foreign educational equivalent) in Computer Science, Data Science or a closely related technical field plus at least 1 year of experience, gained at any time, in each of the below items.

Experience: Depending on degree held, must have at least 3 years or 1 year of experience as described above in each of the following:

• Designing and maintaining EDWs, which store and manage large volumes of data;
• Developing and managing Power BI dashboards, reports, and visualizations;
• Experience with DAX for advanced calculations and Power Query for data transformation;
• Creating complex data models (such as Star Schema, Snowflake Schema) for organizing large datasets for querying and reporting;
• Implementing data quality checks, addressing inconsistencies, and transforming data to ensure accuracy and reliability;
• Experience with cloud-based data storage and analytics platforms such as Azure Data Factory, AWS Redshift, or Google BigQuery; and
• Experience extracting data from multiple data sources, such as MS SQL Server, Oracle, MS Access, Teradata, DB2, Flat files, Excel files.