Please contact your Administrator to change your authorization settings.
FSA Federal (FSA) is focused on delivering unsurpassed services in support of law enforcement and national security. We currently have a vacancy for a Business Intelligence/Data Integration Developer.
FSA's Business Intelligence/Data Integration Developer will report to the Knowledge Manager and will be responsible for building, managing, and maintaining the corporate data warehouse, the processes for populating the warehouse, and corporate reporting utilizing the data warehouse and other data sources across various reporting platforms. This will require a skilled professional who can collect and analyze customer requirements, assemble data from various sources, and determine the best way to deliver the data to the customer while planning for long term maintainability. If you are looking for a meaningful, mission driven career, join FSA!
Duties and Responsibilities Include:
- Consult with internal and external customers to understand the customer's datasets and reporting needs.
- Work with various data sources including SQL Server, SharePoint, Excel, ODBC, and flat files to access and clean data.
- Troubleshoot data and technical issues with reports and warehousing processes.
- Monitor and maintain the data automation processes and reporting systems.
- Add data to the corporate data warehouse using Azure Data Factory for ETL operations.
- Develop advanced reports using Microsoft Power BI Desktop, Microsoft Power BI Report Builder, and Microsoft SQL Server Management Studio (SSMS).
- Deploy reports to the Power BI service and act as the Power BI administrator.
- Develop and maintain advanced Excel data analytics using PowerQuery, DAX, and PowerPivot.
- Develop reporting standards and governance over all of FSA's data and reporting systems.
- Develop data interface processes between various corporate systems.
- Develop PowerApps/PowerAutomate/Azure LogicApps utilities to automate the data integration processes.
- Mentor and train other members of the organization in the use of Power BI.
- Other duties as assigned.
Education and Experience
- Bachelor's degree preferred.
- 4+ years of experience with the Microsoft BI Suite.
- Proven expertise in creating Power BI visualizations, reports, data models, DAX, and SQL database queries.
- Proven experience working with Azure Data Factories or comparable ETL tools.
Competencies / Skills / Abilities
- Mid to Senior level skills in T-SQL, PowerQuery, and DAX.
- Working knowledge of the Azure Portal and the Power BI Cloud Environment.
- Familiarity with Row Level Security (RLS) and managing Power BI Workspace access.
- Familiarity with Power BI Paginated Reports or SSRS.
- Exceptional problem-solving skills with the ability to leverage a wide variety of data and related tools to improve the efficiency of the organization.
- Strong aptitude for understanding and creating ways to visualize data.
- Experience in working with different departments and cross-functional teams, including customer interface and requirements gathering.
- Ability to manage multiple priorities and customer demands.
- Aptitude for creating low-maintenance solutions.
- PowerApps/PowerAutomate/Azure LogicApps preferred, but not required.
- Microsoft Certified Power BI Data Analyst Associate (DA-100 or PL-300) preferred, but not required.
At FSA Federal, we recognize the diverse needs of our employees and strive to provide an excellent package to help meet those needs. Comprehensive benefits are offered with greater choice and flexibility to support your health, work-life balance, and professional growth. A package providing employee only coverage can be built around our basic plans at $0 employee cost for: Medical, Dental, Vision, Term Life Insurance, Accidental Death & Dismemberment Insurance, Short-Term Disability, and Employee Assistance Program. For more information, .
FSA is proud to be an Affirmative Action/ Equal Opportunity Employer. We recruit, employ, train, compensate, and promote qualified persons in all job titles without regard to age, ancestry, color, gender, HIV status, marital status, medical condition, national origin, physical or mental disability, race, religion, sex, sexual orientation (including gender expression and identity) veteran status, family leave status, and any protected group status as defined by applicable law. FSA is proud to maintain a drug-free workplace. Satisfactory completion of a post-offer drug screening is a condition of employment. As a supplier of services to federal government agencies, such as DEA, FBI, USCIS, USPIS, etc., we also adhere to agency standards with respect to prior drug usage. COVID Policy: As a Federal Government Contractor, FSA falls under the guidelines of Executive Order 14042 and the Safer Federal Workforce Taskforce. Prospective and/or new employees will be required to adhere with FSA's COVID -19 Policy and be fully vaccinated before the start of employment. If applicable, during the offer process, prospective or new employees may seek a reasonable accommodation due to a disability (which would include medical conditions) or because of a sincerely held religious belief, practice or observance. While at a Federal workplace, employees must also comply with any additional agency workplace safety requirements for that workplace.