Job Description:
What does a cell phone in your pocket, a spaceship, and an electric vehicle have in common?
Ellsworth Adhesives provides materials in each of those products!
Ellsworth Corporation, a global, industry leading distributor of specialty chemicals and equipment and adhesive manufacturer currently has an IT Data Architect opportunity. This role reports into our corporate headquarters located in Germantown, WI and is an on-site/hybrid role.
Ellsworth Corporation is a family-run company that has had continuous growth for over 50 years. We are an industry-leading global distributor, manufacturer, and packager of adhesives used by cell phone, medical device, space/aerospace, and electric vehicle industries! Click here to see our state-of-the-art facility and distribution center and learn more about our business, and here to find out more about the industries we serve, and here to learn about our consumer and manufacturing divisions.
We are looking for an experienced Data Architect to lead the design and evolution of our enterprise data and analytics environment, with a primary focus on Microsoft Fabric. This role will serve as a subject-matter expert responsible for creating scalable, secure, and supportable data solutions that connect critical business systems and enable trusted reporting and analytics. The ideal candidate brings 7+ years of experience in data architecture, data engineering, business intelligence, or enterprise data platforms, along with strong expertise in Microsoft Fabric or the Microsoft Azure data ecosystem, Power BI, Data Factory, SQL, data warehousing, and dimensional modeling. This is an opportunity for an experienced data professional to help shape Ellsworth's enterprise data strategy while working closely with business leaders, Corporate IT, and external technology partners.
Responsibilities:
- Creates and maintains data architecture definitions, blueprints, standards, and guidelines, including design and architectural reviews
- Leads the design, development, implementation, and support of Microsoft Fabric solutions, including Data Factory, OneLake, Lakehouse, Warehouse, Notebooks, Semantic Models, and Power BI
- Collaborates with business unit stakeholders and subject-matter experts to translate business requirements into data, reporting, and analytics solutions
- Designs and supports enterprise data models, dimensional models, semantic models, and reporting architectures
- Builds and maintains data pipelines, transformations, integrations, and reusable data engineering patterns
- Partners with external consulting firms to review architecture, validate technical decisions, ensure delivered solutions meet Ellsworth standards, and facilitate knowledge transfer for long-term supportability
- Recommends and implements new standards, design patterns, and best practices for data architecture, data engineering, governance, and analytics
- Provides technical leadership for Microsoft Fabric, Power BI, data integration, and enterprise reporting initiatives
- Collaborates with peers in Corporate IT to ensure security, reliability, supportability, and adherence to enterprise technology standards
- Identifies and implements opportunities to improve data platform performance, data quality, reporting delivery, and support processes
PERKS & BENEFITS
As an industry leader, we offer a competitive wage, bonus plan, and a comprehensive benefit package which includes Health, Prescription, Dental, Vision, Life, Disability, Flexible Spending, 401(k), Employee Assistance, Paid Time Off and Holidays, Wellness Program, Social Events, Community Involvement and much more! Click Here for a summary of Employee Benefits.
Qualifications:
- 7+ years of experience in data architecture, data engineering, business intelligence, analytics, or enterprise data platform design in a large-scale enterprise environment.
- Experience with Microsoft Fabric, Azure data services, Power BI, Data Factory, SQL, data warehousing, dimensional modeling, and cloud-based analytics platforms preferred.
- Bachelor’s degree from a four-year college in Computer Science, Information Systems, Data Analytics, Engineering, or related field. Equivalent combinations of education and experience may be considered.
- Advanced knowledge of the architecture, development, and support of enterprise data platforms, analytics solutions, and data integrations.
- Strong knowledge of Microsoft Fabric, including Data Factory, OneLake, Lakehouse, Warehouse, Notebooks, Semantic Models, and Power BI.
- Experience integrating ERP, CRM, and operational business systems into enterprise data and analytics platforms.
- Strong knowledge of SQL, data modeling, dimensional modeling, ETL/ELT development, and cloud-based data architecture.
- Working knowledge of Python, Spark, Azure data services, APIs, and relational database platforms.
- Ability to translate business requirements into scalable data and analytics solutions.
- Strong technical and interpersonal skills, with the ability to build trusted-advisor relationships with stakeholders and recommend appropriate technologies, architectures, and practices.
- Working knowledge of source control, CI/CD deployment practices, Git, and Azure DevOps.
- Ability to partner effectively with external consulting firms while maintaining internal ownership of architecture decisions and long-term supportability.
- Demonstrates leadership by producing quality and timely work, building trust, providing guidance, and maintaining accountability.
- Experience with alternative cloud data platforms such as Databricks, Snowflake, or AWS analytics services to evaluate and integrate best-fit solutions where business requirements extend beyond the Microsoft ecosystem.
Nice-to-have Experience:
- IT Industry Certifications from Microsoft preferred
- Knowledge of advanced data engineering frameworks, including Apache Spark, Delta Lake, Data Mesh, and Lakehouse architectures, to support evolving enterprise analytics and AI initiatives.
#Corp #DataArchitecture #EnterpriseArchitecture #MSFabric #OneLake