Data Architect
Title: Data Architect Job Location: 901 S. Bolmar Street, Suite G, West Chester, PA 19382 and various unanticipated worksites in U.S. 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. #LI-DNI