"Company Introduction
9th Way Insignia is a service-disabled veteran-owned small business bringing transformative technology to our government customers so they can achieve their missions. Our specialties include cybersecurity, cloud modernization, software development, data analytics, enterprise architecture, enterprise IT, process automation, and artificial intelligence. Learn more about 9th Way Insignia at https://9thwayinsignia.com. 

Team (Project) Introduction
The VA’s Office of Information Security (OIS) utilizes the leading data science and automation platform, Alteryx, along with the powerful data visualization platform, Power BI, to develop data processes that distribute crucial cybersecurity reporting throughout OIS. The data warehouse supports analytics and compliance reporting for the agency’s enterprise information systems and is a critical component of the VA’s Information Security and Risk Management Directorate. Operated on-premises and supporting approximately 2,000 users, the OIS data automation platform’s architecture consists of Alteryx Server, MongoDB Enterprise, Microsoft SQL Server, and the Microsoft Power Platform - including Power BI and Power Automate. 

9th Way Insignia is looking for an accomplished Data Engineer/Power BI Developer to join our highly motivated and dedicated team of data engineering and analytic professionals. We are designing and delivering automated data pipelines using process automation tools to create workflows that cleanse and prepare data before populating the cybersecurity data warehouse. We also develop data analytic tools and dashboards that inspect cyber data for evidence of non-compliance with established security controls and automatically alert system owners to mitigate and resolve these issues. 

Professional Level Information:
The Data Engineer/Power BI Developer position aligns as an Engineer - Level 3, at 9th Way Insignia. An Engineer-3 plans and directs research and development on complex projects, leads design and development efforts, and makes recommendations affecting cost decisions and architectural design components. An Engineer-3 oversees the design, development, implementation, and analysis of technical products and systems, has broad knowledge of engineering methodologies, and assists in complex problem resolution. An Engineer-3 has strong technical skills and background, a knack for learning new technologies, and a blend of problem-solving skills and innovative thinking to resolve a wide variety of technical challenges. 

Functional Job (LCAT) Information:
The Data Engineer/Power BI Developerwill be using a combination of Power BI and Alteryx data platforms to prepare and cleanse data for populating a data warehouse used for cybersecurity business intelligence reporting. This is an exciting opportunity to work on a team supporting cybersecurity analytics and data process automation using your data wrangling and visualization skills to help create the foundation needed to support this important work. You and your teammates will be working together to implement state-of-the-art intelligent automation of processes and data preparation using advanced tools like Power BI, Alteryx, SQL, and UI Path.

Qualified candidates should be experienced with the ETL/ELT process, data visualization, and cleansing of file-based and SQL-based data. Experience developing visually compelling dashboards using Power BI is required. Experience creating data automation workflows with the Alteryx platform is a plus. You will help the development team by determining how data will be harvested from available cybersecurity information systems, preparing the data for use, and making it available to the analytics development team by developing automated workflows in Alteryx and downstream reporting in Power BI.

Responsibilities:

 
 
 Design and develop workflows that consume data from file based, SQL, and REST API sources
 ETL scripting, data prep, and cleanse of file-based and SQL-based data using Alteryx, DAX, and PowerQuery (M) languages
 Develop data models and robust visualizations using Power BI
 Write complex SQL queries with multiple joins to automate/manipulate these extracts in Alteryx
 Troubleshoot automation programs/reports already created in Alteryx
 Work with internal customers to refine and clarify requirements
 Optimize our end-to-end use of Alteryx from how we take in data from different sources to how we distribute outputs
 Make use of Alteryx server to schedule, monitor, and enhance workflow performance
 Serve as the back-up admin for Alteryx Server and MongoDB
 
 

 Requirements:

 
 
 BA in MIS, BIS, or other IT concentration, BSCS, or related degree
 Minimum of 3 years working with databases, data modeling, data management, and data curation
 3-5 years of experience developing Power BI models and dashboards
 1-3 years of experience using Alteryx Designer to create data automation workflows
 Data preparation experience using SQL or scripting languages to create ETL processes, perform data cleansing, check data integrity
 Experience writing SQL queries against any RDBMS with query optimization
 SQL RDBMS experience in Microsoft SQL Server
 
 

 
Preferred/Desired:

 
 
 Some experience in UiPath
 Experience using Alteryx server
 Experience performing installation, migration and/or upgrade of Alteryx Servers
 Experience using and managing MongoDB
 
 

 
Salary Range:

Salary: $96,370.33 to $130,000.00 per year

9th Way Insignia’s range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.

Clearance, background investigation:
Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information.

 Tier1 / Low Risk

Location:
100% telework. 9th Way Insignia reserves the right to adjust work location based upon mission requirements.

Legal: 
We’re an equal employment opportunity/affirmative action employer that empowers our people to fearlessly drive change - no matter their race, color, ethnicity, religion, sex (including pregnancy, childbirth, lactation, or related medical conditions), national origin, ancestry, age, marital status, sexual orientation, gender identity and expression, disability, veteran status, military or uniformed service member status, genetic information, or any other status protected by applicable federal, state, local, or international law. hr@9th-way.comPDN-9b9b0989-70e9-43f6-a6e8-ff0a7626fe94"