What are the responsibilities and job description for the Business Intel Architect -III - 2033 position at Certec Consulting?
Business Intel Architect -III
Job ID: CER 2033
Location: Madison, WI, 53703
Schedule: Remote
- Candidate MUST be a WI resident or willing to relocate to WI prior to starting the role at their own expense.
- 100% remote within the State of Wisconsin. Schedule could vary depending on project needs, typically around 25 hours. Shifts will always be on weekdays, and on any day M-F, varying in length per day depending on project.
Terms: 1099 or W2 (No C2C)
Compensation: Hourly Rates listed on SkillsMatrix
Instructions to Apply Online:
- Go to certecinc.com/jobs
- Look for the above Job ID & Click on it to find Job Details
- You will find an URL to SkillsMatrix within the Job Description
- Click on SkillsMatrix URL go to File > Select Download option > Select .doc version, Fill it & Save it
- Now Click on "Apply Now" on the same Job Description page and fill all the required details (Mandatory: Resume, SkillsMatrix, LinkedIn)
Note: Applications via certecinc.com/jobs ONLY will be reviewed
We'll cut off considering resumes on 03/29 at Noon CST.
Our organization is seeking a highly skilled and experienced Business Intelligence Architect III to lead the design, development, and implementation of our enterprise-wide BI solutions. This role will be instrumental in transforming raw data into actionable insights, driving strategic decision-making, and optimizing business performance. The BI Architect III will collaborate with stakeholders across the organization to understand data requirements, design robust data architectures, and ensure the delivery of high-quality, scalable BI solutions.
Responsibilities:
- Design and develop enterprise-level BI architectures, including data warehouses, data marts, and ETL processes.
- Lead the development and implementation of BI solutions, ensuring alignment with business needs and technical requirements.
- Define data modeling standards and best practices and ensure data integrity and consistency across all BI systems.
- Evaluate and recommend BI tools and technologies, staying up-to-date with industry trends and advancements.
- Collaborate with data engineers, data analysts, and business users to gather requirements and translate them into technical specifications.
- Optimize BI performance and scalability, ensuring efficient data processing and retrieval.
- Develop and maintain BI documentation, including data dictionaries, technical specifications, and user guides.
- Provide technical leadership and mentorship to junior BI team members.
- Design and implement data security measures to protect sensitive information.
- Develop and implement data quality processes and metrics.
- Work with stakeholders to define and implement KPI's and dashboards.
- Perform data analysis and identify trends and patterns to support business decision-making.
Qualifications:
- Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
- Minimum of 7-10 years of experience in business intelligence and data warehousing.
- Strong understanding of data warehousing concepts, including dimensional modeling, ETL processes, and OLAP technologies.
- Proficiency in SQL and experience with database management systems (e.g., Oracle, SQL Server, PostgreSQL).
- Experience with BI tools and platforms (e.g., Tableau, Power BI, Looker).
- Experience with cloud-based data warehousing and BI solutions (e.g., AWS Redshift, Azure Synapse, Google BigQuery).
- Strong understanding of data governance and data quality principles.
- Excellent analytical, problem-solving, and communication skills.
- Ability to work independently and as part of a team.
- Experience in data modeling and architecture.
- Experience in performance tuning of BI applications.
- Experience with data integration tools.
Top Skills & Years of Experience:
- Define data modeling standards and best practices and ensure data integrity and consistency across all BI systems. (5 years)
- Collaborate with data engineers, data analysts, and business users to gather requirements and translate them into technical specifications. (3 years)
- Design and develop enterprise-level BI architectures, including data warehouses, data marts, and ETL processes. (5 years)
Nice to have skills:
- Minimum of 7-10 years of experience in business intelligence and data warehousing.
- Strong understanding of data warehousing concepts.
- Experience with BI tools and platforms (e.g., Tableau, Power BI, Looker).
