What are the responsibilities and job description for the Business Intelligence Architect position at SS Solutions?
We are seeking an experienced
Business Intelligence Architect/Developer (Intermediate Level)
to support enterprise analytics and data-driven initiatives. The ideal candidate will bring strong technical expertise in business intelligence, data modeling, and data integration to enable timely, reliable, and actionable insights. This position requires full-cycle experience with ETL, data architecture, reporting solutions, and support for AI/ML applications across complex data environments.This role involves developing robust data solutions using modern BI tools, cloud services, and scalable architectures in environments with multiple data systems, including data lakes, warehouses, and legacy data stores.
The
Business Intelligence Architect/Developer (Intermediate Level)
will be responsible for tasks including but not limited to:
- Design and develop business intelligence solutions to support reporting, analytics, and operational dashboard.
- Define and document requirements, data models, data flows, and system integration processes
- Build and maintain ETL/ELT pipelines using tools like Azure Data Factory, SQL Server Integration Services (SSIS), and Databricks
- Conduct data cleansing, transformation, and denormalization across various structured and semi-structured sources (e.g., JSON, Parquet)
- Develop reports and dashboards using tools like Power BI, SQL Server Reporting Services (SSRS), or Data Studio
- Collaborate with data engineers, data scientists, and stakeholders across multiple domains
- Enable cross-platform data sharing and system interoperability between cloud and on-premise data ecosystems.
- Provide support for AI prompt engineering, ML model integration, and analytics automation initiatives.
Expertise and/or Relevant Experience:
Mandatory Qualifications & Experience - Business Intelligence Architect/Developer (Intermediate Level)
M1. 2–4 years of hands-on experience as a BI Architect or Developer
M2. Experience designing and developing ETL/ELT pipelines and data flows
M3. Strong SQL skills and experience with Microsoft SQL Server and related tools (SSIS, SSRS)
M4. Experience working with modern BI tools such as Power BI, Data Studio, or similar
M5. Understanding of data lakes, warehouses, and lakehouses in platforms such as Snowflake, Teradata, or Azure Synapse
M6. Proficiency working with data formats like JSON and Parquet
Desirable Qualifications - Business Intelligence Architect/Developer (Intermediate Level)
D1. Experience with Microsoft Azure, AWS, or Google Cloud data platforms
D2. Familiarity with Databricks, Apache Spark, and Elastic stack
D3. Background in data science, AI prompt engineering, or machine learning model integration
D4. Experience with R, Python, or SAS for data analysis and statistical computing
D5. Experience architecting cross-system data solutions in complex enterprise environments
D6 Knowledge of data governance, metadata management, and role-based access control
Salary : $100,000 - $140,000
