Business Intelligence Architect I

Position: Business Intelligence Architect I

Hours of Work:

Monday through Friday: 8:30AM-5:00PM

Full Time, Exempt

To the extent permitted by law, the Company may, in its sole discretion, change the work schedule to address business needs. Work hours will depend on the business hours of the time zone serviced.

In This Role, You Will…
Be responsible for contributing to the design and implementation of datasets, integrations, and analytical infrastructure. Provide support and knowledge to deliver cutting-edge solutions as a key member of a highly productive team. Design, develop, and maintain the enterprise architecture.

Responsibilities:

• Gather and process raw data from multiple disparate sources (including writing scripts, calling APIs, write SQL queries, utilizing SSIS, etc.) into a form suitable for analysis.
• With assistance of Team Lead, review and interpret ongoing business requirements, research required data, and build appropriate deliverables.
• Refactor or develop relational data models, dimensional data models, data dictionaries, and necessary metadata using SSAS.
• Research and propose opportunities for data acquisition and new uses for existing data.
• Code, test, and document new or modified data systems to create robust and scalable applications for analytics.
• Work with Team Lead on the design and direction of enterprise-wide data architecture as well as design documentation deliverables.
• In collaboration with Team Leads and Senior Developers, create supporting technical and functional documentation, including data flow diagrams, and provide support for deployed solutions.
• Working in collaboration with our application and SQL developers, design and build high-performance algorithms, prototypes, predictive models, and proof of concepts.
• Create advanced multi-leveled (drill-downs/sub-reports) tabular and graphical reports to meet user requirements using SQL and Microsoft SQL Reporting Services (SSRS) and Power BI.
• Work with senior developers to identify and implement process improvements through the design and implementation of policies, procedures, standardized documentation, and analytics infrastructure to enforce industry best practices.
• Collaborate with Quality Assurance team to ensure valid and proper deliverables.
• Support business decisions with ad-hoc analysis as needed.
• Participate in rotation of after-hours support.
• Explain tasks and processes in a clear and concise manner that can be consumed and understood to non-technical business associates.
• Research new technologies for implementation by the team for producing cutting-edge solutions.
• Cultivate business relationships with stakeholders.
• May perform additional functions depending on market demand and staffing in order to provide consistent quality customer service.

Required:

• Bachelor’s degree in a related discipline (Computer Science, Information Systems Management, Engineering, or similar) or equivalent work experience.
• Advanced knowledge of Microsoft’s SQL Server, SSRS, SSIS, and SSAS.
• Knowledgeable with Power BI, preferably with an on-premises environment.
• Intermediate SQL Query, ETL, and Data Architecture experience.
• Advanced Knowledge and ability in writing complex T-SQL code.
• Ability to quickly identify and troubleshoot problematic SQL code.
• Ability to design tables, data marts, and/or databases to suit reporting needs.
• Knowledge of data mapping, database design, and data warehouse concepts.
• Introductory experience with SQL Database Administration.
• Knowledge using Jira, Bitbucket, GitKraken, and/or SourceTree with a good understanding of Git.
• Desire and ability to learn emerging technologies and methodologies.
• Ability to interpret report requests and requirements in order to build appropriate automated solutions.
• Ability to work with shifting deadlines in a fast-paced environment.
• Strong computer skills, including Microsoft Office (Access, Excel, Word, & Outlook).
• Strong attention to detail, interpersonal skills, and notation skills.

Preferred Qualifications:

• Knowledge of OLAP services.
• Introductory experience with SQL Database Administration.
• Experience using Jira, Bitbucket, GitKraken, and/or SourceTree.
• Knowledge of data mapping, database design, and data warehouse concepts.

 IND3

#LI-Remote 

#LI-JA2

Physical Demands:
While performing the duties of this job, the employee is frequently required to sit for extended periods; reach with hands and arms; and talk or hear. The employee is occasionally required to stand and walk. The employee must occasionally lift and/or move up to twenty (20) pounds. Specific vision abilities required by this job include close vision and the ability to adjust focus.

This job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee. Duties, responsibilities, and activities may change or new ones may be assigned at any time or without notice.