Data Architect

Posted 5 Days Ago
Be an Early Applicant
Pittsburgh, PA, USA
In-Office
Mid level
Database • Analytics
The Role
Designs and implements production-ready data models, data warehouses, pipelines, and ETL processes. Translates business requirements into actionable data architecture plans, applies dimensional and tabular modeling patterns, and establishes database and ETL best practices. Collaborates with business and technical teams throughout the data analytics lifecycle, works across SDLC environments, directs ETL development, and optimizes scheduling and performance using cloud platforms, Google BigQuery, SQL, and Power BI.
Summary Generated by Built In

Data Ideology

At DI, we provide Data & Analytics expertise to drive measurable business outcomes, often solving complex business problems for our clients. Our data analytics advisory services enable our customers to transform data into insights by driving a culture of empowerment and ownership of results. Our team consists of highly motivated individuals passionate about learning, understanding, collaborating, and intellectually curious.  For more information about Data Ideology, visit www.dataideology.com 

Data Architect - Full-time

We are looking for a Data Architect to join our growing team. Data Architect will leverage their business and technical knowledge to develop production-ready data models by integrating multiple data sources while working with business and technical teams to understand business strategy and objectives, gather information, and ensure business requirements are being fulfilled throughout the entire data & analytics lifecycle.

Key Responsibilities

To perform in this position successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. Other duties may be assigned to meet business needs.

  • Ability to collect and understand business requirements and translate those requirements into an actionable data warehouse plan.
  • Knowledge of multi-dimensional and tabular design patterns and ability to identify solutions that leverage these modeling techniques.
  • Ability to work within the SDLC framework in multiple environments and understand the complexities and dependencies of the data warehouse built within those constraints.
  • Ability to define and implement best practices across database design and ETL.
  • Ability to direct the work of others, including but not limited to directing ETL development, demonstrating an understanding of key concepts of ETL/ELT, including best practices for optimization and scheduling.

Supervisory Responsibilities: None

Qualifications

Education and Experience:

  • Proven understanding of Data warehousing, Data Architecture, and BI.
  • Experience with data pipelines and architecture/engineering.
  • Knowledge of modern apps and data platforms.
  • Cloud-based project implementation.
  • Google BigQuery experience

Knowledge, Skills, and Abilities:

  • BI/Data Warehousing (3+ years) - Google BigQuery
  • Cloud platforms (1+ years) - Google Cloud Platform
  • Dimensional Data Modeling ( 3+ years)
  • ETL (3+ years) 
  • SQL (3+ years)
  • Busienss Intelligence (1+ years) - Power BI

Work Environment:

  • Remote work from home.
  • Hours of work and days are generally Monday through Friday. Specific business hours will depend on client needs.

Physical Demands:

  • Must be able to remain in a stationary position 50% of the time.
  • The person in this position must occasionally move about inside the office to access file cabinets, library stacks, office machinery, etc.
  • Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine, and printer.
  • The person in this position frequently communicates with clients and coworkers. Must be able to exchange accurate information in these situations.

Benefits:  

  • Unlimited Discretionary Time Off Policy
  • 100% company paid - insurance (medical, dental, vision) for employees
  • 100% company paid - short and long-term disability insurance for employees
  • 100% company paid - life insurance and AD&D insurance for employees
  • 100% company paid – employee assistance program
  • Retirement plans with company match
  • Training and Certification Reimbursement annually
  • Performance-based incentive program
  • Commission incentive program
  • Profit Sharing Plan
  • Referral Bonuses

Data Ideology is an EEO Employer

Skills Required

  • 3+ years of BI and data warehousing experience, including Google BigQuery
  • 1+ year of cloud platform experience, including Google Cloud Platform
  • 3+ years of dimensional data modeling experience
  • 3+ years of ETL experience
  • 3+ years of SQL experience
  • 1+ year of business intelligence experience, including Power BI
  • Experience with data pipelines and data architecture or engineering
  • Knowledge of modern applications and data platforms
  • Experience with cloud-based project implementation
  • Ability to collect business requirements and translate them into data warehouse plans
  • Knowledge of multidimensional and tabular design patterns
  • Understanding of SDLC environments and data warehouse dependencies
  • Ability to define and implement database design and ETL best practices
  • Understanding of ETL and ELT optimization and scheduling
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Pittsburgh, PA
43 Employees
Year Founded: 2017

What We Do

Based in Pittsburgh, Pennsylvania, Data Ideology is the region's fastest-growing data & analytics consultancy serving the area’s largest enterprises in healthcare and technology. Our team consists of highly competitive individuals who are experts in the field and passionate about data and the value it can bring to organizations. We specialize in data warehouse modernization , data warehouse migration, eliminating data silo’s , data governance , data visualization , and enterprise deployment , bringing data together , eliminating complexity and providing top-notch training solutions. At Data Ideology, we drive a culture of empowerment at the top level of management and ownership of results so that our customers win every day. Our main focus is on our clients, as well as on their processes, data and technology to help them realize greater value with their analytics investments. We work one on one with companies to leverage their data assets by implementing our methodology and framework to strengthen the strategic value of data within their organizations, respectively.

Similar Jobs

Federal Reserve Bank of Boston Logo Federal Reserve Bank of Boston

Data Architect

Fintech • Information Technology • Payments • Sharing Economy • Financial Services • Cryptocurrency
In-Office
12 Locations
1200 Employees
140K-170K Annually

Dynatrace Logo Dynatrace

Data Architect

Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Remote or Hybrid
United States
5600 Employees
160K-180K Annually

CDW Logo CDW

Data Architect

Information Technology
Remote or Hybrid
US
15100 Employees
128K-193K Annually

Perficient Logo Perficient

Data Architect

Information Technology
In-Office or Remote
3 Locations
3295 Employees
135K-165K Annually

Similar Companies Hiring

Northslope Thumbnail
Artificial Intelligence • Information Technology • Software • Analytics • Consulting • Generative AI
London, GB
100 Employees
Scotch Thumbnail
Artificial Intelligence • eCommerce • Fintech • Payments • Retail • Software • Analytics
US
35 Employees
Milestone Systems Thumbnail
Artificial Intelligence • Security • Software • Analytics • Big Data Analytics
Lake Oswego, OR
1500 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account