Business Intelligence Data Systems Architect

This is a fully remote position, open to applicants in United States.

📋 Description

• Research, develop, configure, implement, design, and proactively oversee and manage Trillium’s Power BI Reporting Platform.

• Evaluate the organization’s reporting requirements and assist in formulating a long-term reporting strategy.

• Lead, plan, coordinate, and manage the development, documentation, and implementation of reporting systems.

• Offer technical support concerning systems capabilities for Information Technology projects.

• Provide training to IT and Trillium staff as required and directed.

• Design, construct, test, deploy, document, and sustain Power BI reporting solutions and semantic models.

• Create and manage SQL queries, data pipelines, and related systems that drive reporting solutions.

• Continuously evaluate the platform's capabilities, performance, and governance.

• Research, develop, test, deploy, and document innovative data ingestion, processing, transmission, and sharing methods and tools in collaboration with IT teams.

• Plan, coordinate, and implement security protocols, including regular audits, for reporting platforms and computer files.

• Define users and their access levels for various segments of the reporting platform.

• Select, develop, and implement code to monitor the performance of the reporting platform.

• Create reference and workflow documents.

• Update agency data definitions in the data dictionary for reporting and visualizations.

⛳️ Requirements

• Associate's degree coupled with four (4) years of experience in information technology, data analytics, or reporting development.

• Familiarity with n-tier development and support methodologies.

• Understanding of relational and data warehouse development.

• Knowledge of extract-transform-load processes.

• Proficiency in Structured Query Language (SQL).

• Certification is required.

• Two-year degrees must include certification.

• A valid driver's license is essential.

• Residency within the United States is mandatory.

• Preferred: Degree in Information Technology / MIS, Mathematics, Engineering Sciences, Data Analytics, Business, Human Services, and/or Healthcare Administration.

• Preferred: Microsoft data systems certifications such as MTA, MCSA, MCSE, ITIL v3, Power BI, INFORMS, IIBA, AWS, Azure, or relevant certifications.

• All candidates must successfully pass a drug test prior to employment.

🏝️ Benefits

• A collaborative, mission-driven work environment.

• Competitive benefits and the option to work from home for most positions.

• Opportunities for professional development within a diverse and inclusive culture.

• Flexible work schedules available with management approval for certain roles.

• Work-from-home options accessible for the majority of positions.

• Health Insurance with no premium required for employee coverage.

• Flexible Spending Accounts.

• 24 days of Paid Time Off (PTO) plus 12 paid holidays in your first year.

• NC Local Government Retirement Pension (defined-benefit plan).

• 401k with a 5% employer match and immediate vesting.

• Public Service Loan Forgiveness (PSLF) qualifying employer.

• Quarterly stipend for remote work supplies.